<%@ page language="java" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib uri="/WEB-TAG/platForm.tld" prefix="PF"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<base href="<PF:basePath/>">
		<title>数据查询器数据管理</title>
		<meta http-equiv="content-type" content="text/html; charset=UTF-8">
		<jsp:include page="/WEB-FACE/conf/includeH.jsp"></jsp:include>
	</head>
	<body class="easyui-layout">
		<div data-options="region:'west',split:true,border:false"
			style="width: 250px;">
			<div class="TREE_COMMON_BOX_SPLIT_DIV">
				<a id="QueryTreeReload" href="javascript:void(0)"
					class="easyui-linkbutton" data-options="plain:true"
					iconCls="icon-reload">刷新菜单</a>
				<a id="QueryTreeOpenAll" href="javascript:void(0)"
					class="easyui-linkbutton" data-options="plain:true"
					iconCls="icon-sitemap">全部展开</a>
			</div>
			<ul id="QueryTree"></ul>
		</div>
		<div class="easyui-layout" data-options="region:'center',border:false">
			<div data-options="region:'north',border:false">
				<form id="searchQueryForm">
					<table class="editTable">
						<tr>
							<td class="title">
								类型:
							</td>
							<td>
								<input id="PARENTTITLE_RULE" type="text" readonly="readonly"
									style="background: #F3F3E8">
								<input id="PARENTID_RULE" name="TYPEID:=" type="hidden">
							</td>
							<td class="title">
								查询名称:
							</td>
							<td>
								<input name="NAME:like" type="text">
							</td>
							<td class="title">
								内建视图:
							</td>
							<td>
								<input name="FROMSTR:like" type="text">
							</td>
						</tr>
						<tr style="text-align: center;">
							<td colspan="6">
								<a id="a_search" href="javascript:void(0)"
									class="easyui-linkbutton" iconCls="icon-search">查询</a>
								<a id="a_reset" href="javascript:void(0)"
									class="easyui-linkbutton" iconCls="icon-reload">清除条件</a>
							</td>
						</tr>
					</table>
				</form>
			</div>
			<div data-options="region:'center',border:false">
				<table id="dataQueryGrid">
					<thead>
						<tr>
							<th data-options="field:'ck',checkbox:true"></th>
							<th field="TYPENAME" data-options="sortable:true" width="80">
								分类
							</th>
							<th field="NAME" data-options="sortable:true" width="80">
								查询名称
							</th>
							<th field="PAGESIZE" data-options="sortable:true" width="70">
								每页显示记录数
							</th>
							<th field="DISTINCTABLE" data-options="sortable:true" width="40">
								是否去重
							</th>
							<th field="CACHETIME" data-options="sortable:true" width="130">
								缓存过期时间（空为不缓存）
							</th>
							<th field="REPORTMAXNUM" data-options="sortable:true" width="100">
								报表最大导出记录数量
							</th>
							<th field="PCONTENT" data-options="sortable:true" width="20">
								备注
							</th>
							<th field="REPORTABLE" data-options="sortable:true" width="60">
								是否导出报表
							</th>
						</tr>
					</thead>
				</table>
			</div>
		</div>
	</body>
	<script type="text/javascript">
	var url_delActionQuery = "admin/FarmFormsQuerydeleteCommit.do";//删除URL
	var url_formActionQuery = "admin/FarmFormsQueryTabs.do";//增加、修改、查看URL
	var url_searchActionQuery = "admin/FarmFormsQueryQuery.do";//查询URL
	var title_windowQuery = "数据查询器管理";//功能名称
	var gridQuery;//数据表格对象
	var searchQuery;//条件查询组件对象
	var toolBarQuery = [ {
		id : 'view',
		text : '查看',
		iconCls : 'icon-tip',
		handler : viewDataQuery
	}, {
		id : 'add',
		text : '新增',
		iconCls : 'icon-add',
		handler : addDataQuery
	}, {
		id : 'edit',
		text : '修改',
		iconCls : 'icon-edit',
		handler : editDataQuery
	}, {
		id : 'del',
		text : '删除',
		iconCls : 'icon-remove',
		handler : delDataQuery
	} ];
	$(function() {
		//初始化数据表格
		gridQuery = $('#dataQueryGrid').datagrid( {
			url : url_searchActionQuery,
			fit : true,
			fitColumns : true,
			'toolbar' : toolBarQuery,
			pagination : true,
			closable : true,
			checkOnSelect : true,
			border:false,
			striped : true,
			rownumbers : true,
			ctrlSelect : true
		});
		//初始化条件查询
		searchQuery = $('#searchQueryForm').searchForm( {
			gridObj : gridQuery
		});
		$('#QueryTree').tree( {
			url : 'admin/FarmFormsFormcategoryloadTree.do',
			onSelect : function(node) {
				$('#PARENTID_RULE').val(node.id);
				$('#PARENTTITLE_RULE').val(node.text);
				searchQuery.dosearch( {
					'query.ruleText' : searchQuery.arrayStr()
				});
			}
		});
		$('#QueryTreeReload').bind('click', function() {
			$('#QueryTree').tree('reload');
		});
		$('#QueryTreeOpenAll').bind('click', function() {
			$('#QueryTree').tree('expandAll');
		});
	});
	//查看
	function viewDataQuery() {
		var selectedArray = $(gridQuery).datagrid('getSelections');
		if (selectedArray.length == 1) {
			var url = url_formActionQuery + '?pageset.pageType='
					+ PAGETYPE.VIEW + '&ids=' + selectedArray[0].ID;
			$.farm.openWindow( {
				id : 'winQuery',
				width : 800,
				height : 400,
				modal : true,
				url : url,
				title : '浏览'
			});
		} else {
			$.messager.alert(MESSAGE_PLAT.PROMPT, MESSAGE_PLAT.CHOOSE_ONE_ONLY,
					'info');
		}
	}
	//新增
	function addDataQuery() {
		if ($('#PARENTID_RULE').val() == null
				|| $('#PARENTID_RULE').val() == '') {
			$.messager.alert(MESSAGE_PLAT.PROMPT, "请选择分类!", 'info');
			return;
		}
		var url = url_formActionQuery + '?type.id=' + $('#PARENTID_RULE').val()
				+ '&pageset.pageType=' + PAGETYPE.ADD;
		$.farm.openWindow( {
			id : 'winQuery',
			width : 800,
			height : 400,
			modal : true,
			url : url,
			title : '新增'
		});
	}
	//修改
	function editDataQuery() {
		var selectedArray = $(gridQuery).datagrid('getSelections');
		if (selectedArray.length == 1) {
			var url = url_formActionQuery + '?pageset.pageType='
					+ PAGETYPE.EDIT + '&ids=' + selectedArray[0].ID;
			$.farm.openWindow( {
				id : 'winQuery',
				width : 800,
				height : 400,
				modal : true,
				url : url,
				title : '修改'
			});
		} else {
			$.messager.alert(MESSAGE_PLAT.PROMPT, MESSAGE_PLAT.CHOOSE_ONE_ONLY,
					'info');
		}
	}
	//删除
	function delDataQuery() {
		var selectedArray = $(gridQuery).datagrid('getSelections');
		if (selectedArray.length > 0) {
			// 有数据执行操作
			var str = selectedArray.length + MESSAGE_PLAT.SUCCESS_DEL_NEXT_IS;
			$.messager.confirm(MESSAGE_PLAT.PROMPT, str, function(flag) {
				if (flag) {
					$(gridQuery).datagrid('loading');
					$.post(url_delActionQuery + '?ids='
							+ $.farm.getCheckedIds(gridQuery, 'ID'), {},
							function(flag) {
								$(gridQuery).datagrid('loaded');
								if (flag.pageset.commitType == 0) {
									$(gridQuery).datagrid('reload');
								} else {
									var str = MESSAGE_PLAT.ERROR_SUBMIT
											+ flag.pageset.message;
									$.messager.alert(MESSAGE_PLAT.ERROR, str,
											'error');
								}
							});
				}
			});
		} else {
			$.messager.alert(MESSAGE_PLAT.PROMPT, MESSAGE_PLAT.CHOOSE_ONE,
					'info');
		}
	}
</script>
</html>